Show All

Display numbers as fractions or percentages

1. Select the cells you want to format.
2. On the Format menu, click Cells, and then click the Number tab.
3. Do one of the following:
   • To display numbers as fractions, click Fraction in the Category list, and then click the type of fraction you want to use.
   • To display numbers as percentages, click Percentage in the Category list. In the Decimal places box, enter the number of decimal places you want to display.
   • To quickly display numbers as percentages of 100, click Percent Style on the Formatting toolbar.

   Note  Numbers above 1 are automatically entered as percentages; and numbers below 1 are converted to percentages by multiplying by 100. For example, entering 10 results in 10%, and entering .1 results in 10%. To have all numbers converted by multiplying by 100, on the Tools menu, click Options, click the Edit tab, and then clear the Enable automatic percent entry check box.